Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
BusinessUnitGroupID (FK)(PK) | A unique system assigned identifier for a group of BusinessUnits. | ID_BSNGP | Identity | integer | BusinessUnitGroup(CO_BSNGP) |
BusinessUnitID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | BusinessUnit(LO_BSN_UN) |
StartsDateTime | The date and time the ReportingPeriod started for the BusinessUnit | TS_SRT | AuditDateTime | datetime | |
EndsDateTime | The date and time the ReportingPeriod ended for the BusinessUnit | TS_END | AuditDateTime | datetime | |
StartTransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN_SRT | IdentityUUID | char(32) | PeriodOpenTransaction(TR_PRD_OPN) |
EndTransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN_END | IdentityUUID | char(32) | PeriodCloseTransaction(TR_PRD_CL) |